db.silva.inrae.fr/db_biljou_param - db_biljou_param on db.silva.inrae.fr
Previous topic Chapter index Next topic

Check Constraints

 

Schema

Table

Check Constraint

Condition

Description

public

geo_raster_agri4cast

enforce_height_rast

st_height(rast) = 50

 

public

geo_raster_agri4cast

enforce_max_extent_rast

st_envelope(rast) @ '0103000020DB0B0000010000000500000000000000006A384100000000904A11C100000000006A384100000000DBC256410000000004F25D4100000000DBC256410000000004F25D4100000000904A11C100000000006A384100000000904A11C1'::geometry

 

public

geo_raster_agri4cast

enforce_nodata_values_rast

_raster_constraint_nodata_values(rast) = '{0.0000000000}'::numeric[]

 

public

geo_raster_agri4cast

enforce_num_bands_rast

st_numbands(rast) = 1

 

public

geo_raster_agri4cast

enforce_out_db_rast

_raster_constraint_out_db(rast) = '{f}'::boolean[]

 

public

geo_raster_agri4cast

enforce_pixel_types_rast

_raster_constraint_pixel_types(rast) = '{32BUI}'::text[]

 

public

geo_raster_agri4cast

enforce_same_alignment_rast

st_samealignment(rast, '010000000000000000006AD84000000000006AD8C000000000006A384100000000DBC2564100000000000000000000000000000000DB0B000001000100'::raster)

 

public

geo_raster_agri4cast

enforce_scalex_rast

round((st_scalex(rast))::numeric, 10) = round((25000)::numeric, 10)

 

public

geo_raster_agri4cast

enforce_scaley_rast

round((st_scaley(rast))::numeric, 10) = round((- (25000)::numeric), 10)

 

public

geo_raster_agri4cast

enforce_srid_rast

st_srid(rast) = 3035

 

public

geo_raster_agri4cast

enforce_width_rast

st_width(rast) = 50

 

public

geo_raster_france_1pixel

enforce_height_rast

st_height(rast) = 1

 

public

geo_raster_france_1pixel

enforce_max_extent_rast

st_envelope(rast) @ '01030000206A08000001000000050000003C1807B09F66F840000000005C1057413C1807B09F66F84000000000A3295B41847100FB4A6E334100000000A3295B41847100FB4A6E3341000000005C1057413C1807B09F66F840000000005C105741'::geometry

 

public

geo_raster_france_1pixel

enforce_num_bands_rast

st_numbands(rast) = 1

 

public

geo_raster_france_1pixel

enforce_out_db_rast

_raster_constraint_out_db(rast) = '{f}'::boolean[]

 

public

geo_raster_france_1pixel

enforce_pixel_types_rast

_raster_constraint_pixel_types(rast) = '{8BUI}'::text[]

 

public

geo_raster_france_1pixel

enforce_same_alignment_rast

st_samealignment(rast, '010000000000000000E1E73141000000001C6530C13C1807B09F66F84000000000A3295B41000000000000000000000000000000006A08000001000100'::raster)

 

public

geo_raster_france_1pixel

enforce_scalex_rast

round((st_scalex(rast))::numeric, 10) = round((1173473)::numeric, 10)

 

public

geo_raster_france_1pixel

enforce_scaley_rast

round((st_scaley(rast))::numeric, 10) = round((- (1074460)::numeric), 10)

 

public

geo_raster_france_1pixel

enforce_srid_rast

st_srid(rast) = 2154

 

public

geo_raster_france_1pixel

enforce_width_rast

st_width(rast) = 1

 

public

geo_raster_france_8km_safran

enforce_height_rast

st_height(rast) = 50

 

public

geo_raster_france_8km_safran

enforce_max_extent_rast

st_envelope(rast) @ '0103000020B46B00000100000005000000000000000058EB4000000000C8A83641000000000058EB4000000000247C444100000000402A334100000000247C444100000000402A334100000000C8A83641000000000058EB4000000000C8A83641'::geometry

 

public

geo_raster_france_8km_safran

enforce_nodata_values_rast

_raster_constraint_nodata_values(rast) = '{0.0000000000}'::numeric[]

 

public

geo_raster_france_8km_safran

enforce_num_bands_rast

st_numbands(rast) = 1

 

public

geo_raster_france_8km_safran

enforce_out_db_rast

_raster_constraint_out_db(rast) = '{f}'::boolean[]

 

public

geo_raster_france_8km_safran

enforce_pixel_types_rast

_raster_constraint_pixel_types(rast) = '{16BUI}'::text[]

 

public

geo_raster_france_8km_safran

enforce_same_alignment_rast

st_samealignment(rast, '0100000000000000000040BF40000000000040BFC0000000000058EB4000000000247C444100000000000000000000000000000000B46B000001000100'::raster)

 

public

geo_raster_france_8km_safran

enforce_scalex_rast

round((st_scalex(rast))::numeric, 10) = round((8000)::numeric, 10)

 

public

geo_raster_france_8km_safran

enforce_scaley_rast

round((st_scaley(rast))::numeric, 10) = round((- (8000)::numeric), 10)

 

public

geo_raster_france_8km_safran

enforce_srid_rast

st_srid(rast) = 27572

 

public

geo_raster_france_8km_safran

enforce_width_rast

st_width(rast) = 50

 

public

geo_raster_france_90m_fv2

enforce_height_rast

st_height(rast) = ANY (ARRAY[50, 2])

 

public

geo_raster_france_90m_fv2

enforce_max_extent_rast

st_envelope(rast) @ '01030000206A08000001000000050000003C1807B09F66F8408C908008F05857413C1807B09F66F84000000000DF1F5B41A25168DCDEC8304100000000DF1F5B41A25168DCDEC830418C908008F05857413C1807B09F66F8408C908008F0585741'::geometry

 

public

geo_raster_france_90m_fv2

enforce_num_bands_rast

st_numbands(rast) = 1

 

public

geo_raster_france_90m_fv2

enforce_out_db_rast

_raster_constraint_out_db(rast) = '{f}'::boolean[]

 

public

geo_raster_france_90m_fv2

enforce_pixel_types_rast

_raster_constraint_pixel_types(rast) = '{32BUI}'::text[]

 

public

geo_raster_france_90m_fv2

enforce_same_alignment_rast

st_samealignment(rast, '01000000009C128C03D87F564018D71C3CC47F56C03C1807B09F66F84000000000DF1F5B41000000000000000000000000000000006A08000001000100'::raster)

 

public

geo_raster_france_90m_fv2

enforce_scalex_rast

round((st_scalex(rast))::numeric, 10) = round(89.9975594394586, 10)

 

public

geo_raster_france_90m_fv2

enforce_scaley_rast

round((st_scaley(rast))::numeric, 10) = round('-89.9963522225993'::numeric, 10)

 

public

geo_raster_france_90m_fv2

enforce_srid_rast

st_srid(rast) = 2154

 

public

geo_raster_france_90m_fv2

enforce_width_rast

st_width(rast) = ANY (ARRAY[50, 12])

 

public

geo_raster_france_90m_gsm

enforce_height_rast

st_height(rast) = ANY (ARRAY[50, 2])

 

public

geo_raster_france_90m_gsm

enforce_max_extent_rast

st_envelope(rast) @ '01030000206A08000001000000050000003C1807B09F66F8408C908008F05857413C1807B09F66F84000000000DF1F5B41A35168DCDEC8304100000000DF1F5B41A35168DCDEC830418C908008F05857413C1807B09F66F8408C908008F0585741'::geometry

 

public

geo_raster_france_90m_gsm

enforce_num_bands_rast

st_numbands(rast) = 1

 

public

geo_raster_france_90m_gsm

enforce_out_db_rast

_raster_constraint_out_db(rast) = '{f}'::boolean[]

 

public

geo_raster_france_90m_gsm

enforce_pixel_types_rast

_raster_constraint_pixel_types(rast) = '{32BUI}'::text[]

 

public

geo_raster_france_90m_gsm

enforce_same_alignment_rast

st_samealignment(rast, '01000000009D128C03D87F564018D71C3CC47F56C03C1807B09F66F84000000000DF1F5B41000000000000000000000000000000006A08000001000100'::raster)

 

public

geo_raster_france_90m_gsm

enforce_scalex_rast

round((st_scalex(rast))::numeric, 10) = round(89.99755943945861, 10)

 

public

geo_raster_france_90m_gsm

enforce_scaley_rast

round((st_scaley(rast))::numeric, 10) = round('-89.99635222259928'::numeric, 10)

 

public

geo_raster_france_90m_gsm

enforce_srid_rast

st_srid(rast) = 2154

 

public

geo_raster_france_90m_gsm

enforce_width_rast

st_width(rast) = ANY (ARRAY[50, 12])

 

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23
Previous topic Chapter index Next topic